Release 10.1A: OpenEdge Development:
Progress Dynamics Basic Development

Assigning a site number to your database

Once you have obtained a site number for your Repository database, you can enter the numbers into the database.

To enter a site number in your database:

From the AppBuilder main window, select Build Set Site Number. (You can also select this option from the Administration window’s System menu.)

The Set Site Number dialog box appears, as shown:



Enter your Site Number in the field provided for the Progress Dynamics Repository Database (ICFDB).

The site number is stored as the fractional part of each object ID, to the right of the decimal point or comma. To ensure that trailing zeroes in the site number do not lose their significance (for example, so that site number 70 and site number 700 become distinct values, which would not be the case for .70 and .700), the site number is reversed before it is applied to the key. The Site Sequence is the actual decimal fraction that becomes part of every object ID key.

The whole number portion of the object ID is constructed from two database sequences, forming the high-order and low-order portions of a large integer value, to assure support for a sufficiently large number. The number must accommodate the largest possible number of records in your Repository database, since every record in every table will have a unique ID number. You can adjust the starting values for those sequences in the Set Site Number dialog box. Site Sequence 1 is the low-order portion of the object ID key, and Site Sequence 2 is the high-order portion. When the low-order Site Sequence 1 reaches its maximum value and rolls over back to 1, the trigger procedure that assigns object IDs automatically increments the high-order Site Sequence 2.

Note: Progress Dynamics does not automatically assign object IDs to records in an application database. You have to implement your own logic to do this based on the principles that Progress Dynamics uses.

There is also a unique session ID assigned to each database for each session. This is used to form a key for context data that might be stored for the session by the Session Manager. This Session ID number is also displayed, and you can modify it if necessary (normally it will not be) by selecting the Update Sequence Values toggle box.